Shaine Greenwood
Shaine Greenwood
Reactions
-
Re: 20th of the following month formula
Looks like I just misplaced my end paren on the month. I've tested this out: =DATE(YEAR(Finish1), MONTH(Finish1) + 1, 20) It returns 2/20/17 based on another date cell with 1/1/17 entered.1 · -
Re: IF, AND, OR Functions
Hi dana, If you're getting an #UNPARSEABLE error on your second formula, it's likely due to the mixture of straight quotes vs curly quotes. Smartsheet can only understand straight quotes in formulas.…2 · -
Re: COUNTIF USING OR
Hi Tee, If you're looking to have your COUNTIF count anything that meets one of multiple criteria, then you can use a formula like the following example: =COUNTIF(CHILDREN([Status1:Status17), OR(@cel…1 · -
Re: Conditional formatting in Calendar View
Steve, It sounds like you're running into the same exact behavior that Ginny ran into—the same recommendation I gave to her should work for you as well. Please edit your conditional formatting rules …1 ·
